Several Different Masters -> Single Slave Replication?
I want to replication multiple master mysql databases on different hosts to one single slave host.
There doesn't seem to be anything in the MySQL Reference manual on this.
It's my guess that this would require multiple database instances, each with their own datadir on the slave host?
To be clear, what I am talking about is NOT multi-master replication, but actually having separate distinct master databases doing completely different things, but having replicas running on one single host system.
So you have to different databases (different servers I assume) that you want to replicate on 1 other machine?
You simply need to enable replication for each, assuming they don't have the same database names.
Running separate mysql instances is the way to solve that.
To be able to run separate instances on the same machine you will have to create different my.cnf files for each instance where you also will have to specify different TCP ports and different datadirs since the different instances can't run against the same physical DB files.
Here you have an example of things that need to be different on each instance: